home *** CD-ROM | disk | FTP | other *** search
/ New Perspectives on Computer Concepts / New Perspectives on Computer Concepts.iso / np2010c / page686.pag < prev    next >
Portable Network Graphic  |  2008-10-02  |  82KB  |  817x1045  |  8-bit (256 colors)
Labels: chat room | hakham | laptop | monitor | sky
OCR: SECTION CHAPTER 11 What's a relational database? relational database stores data in collection of related tables. Each table sequence of records, simi- lar to flat file All the records in table are of the same record type Each row of table is equivalent to record Each column of the table equivalent field. relational database typically contains several FIGURE 11-12 tables. For example the Vintage Music Shop's database uses six tables Vintage Music Shop stores data to store data as shown in Figure 11-12 n six tables ALBUM DESCRIPTION TRACKS Track Cat# Description Cat# TrackTitle TrackSample Length ORDER DETAILS OrderNumber Cat# QTY DiscountPrice ORDERS OrderNumber CustomerNumber: TotalPrice OrderDate CUSTOMERS CustomerNumber FirstName: LastName: Street City: ALBUMS Release Cat# AlbumTitle Ar ...